INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause' SQL QUERY FAILURE: SELECT xcart_pricing.price , t1.value as extra FROM xcart_products, xcart_pricing , xcart_products_categories, xcart_extra_field_values as t1, xcart_extra_fields as s1 LEFT JOIN xcart_extra_field_values ON xcart_products.productid = xcart_extra_field_values.productid LEFT JOIN xcart_extra_fields ON xcart_extra_field_values.fieldid = xcart_extra_fields.fieldid AND xcart_extra_fields.active = 'Y' WHERE xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_pricing.variantid = 0 AND ((xcart_extra_field_values.value LIKE '%10inch Single%' AND xcart_extra_fields.fieldid = '1')) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid='8' AND (xcart_products_categories.main='Y' OR xcart_products_categories.main!='Y') AND xcart_products.forsale='Y' AND xcart_products.productid = t1.productid AND t1.fieldid = s1.fieldid AND s1.field='Author' AND (xcart_products.avail>0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause' SQL QUERY FAILURE: SELECT xcart_pricing.price , t1.value as extra FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_extra_field_values as t1, xcart_extra_fields as s1 LEFT JOIN xcart_extra_field_values ON xcart_products.productid = xcart_extra_field_values.productid LEFT JOIN xcart_extra_fields ON xcart_extra_field_values.fieldid = xcart_extra_fields.fieldid AND xcart_extra_fields.active = 'Y' WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='8' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_pricing.variantid = 0 AND ((xcart_extra_field_values.value LIKE '%10inch Single%' AND xcart_extra_fields.fieldid = '1')) AND xcart_products_categories.productid=xcart_products.productid AND xcart_products.forsale='Y' AND xcart_products.productid = t1.productid AND t1.fieldid = s1.fieldid AND s1.field='Author' AND (xcart_products.avail>0 OR xcart_products.product_type NOT IN ('','N')) GROUP BY xcart_products.productid
Online record and book shop, second hand records and rare books.
Children's
:: Music
:: Elvis Shakespeare
